
/*
*备注：附加属性表
*时间：2014年3月3日 13:58:36
*/

CREATE TABLE Base_AppendProperty
(
	Property_ID varchar2(50) not null primary key,
	Property_Function varchar2(50),
	Property_FunctionUrl varchar2(200),
	Property_Control_ID varchar2(50),
	Property_Name varchar2(50),
	Property_Control_Type int,
	Property_Control_DataSource varchar2(3500),
	Property_Control_Length varchar2(50),
	Property_Control_Maxlength int,
	Property_Control_Style varchar2(50),
	Property_Control_Validator varchar2(50),
	Property_Colspan int ,
	Property_Event varchar2(200),
	SortCode int,
	DeleteMark int default(1),
	CreateDate date default(sysdate),
	CreateUserId varchar2(50),
	CreateUserName varchar2(50),
	ModifyDate date,
	ModifyUserId varchar2(50),
	ModifyUserName varchar2(50)
);

comment on table Base_AppendProperty is '附加属性表';
comment on table Base_AppendProperty.Property_ID is '附加属性主键';
comment on table Base_AppendProperty.Property_Function is '所属功能';
comment on table Base_AppendProperty.Property_FunctionUrl is '功能路径';
comment on table Base_AppendProperty.Property_Control_ID is '控件ID';
comment on table Base_AppendProperty.Property_Name is '属性名称';
comment on table Base_AppendProperty.Property_Control_Type is '控件类型';
comment on table Base_AppendProperty.Property_Control_DataSource is '控件数据源';
comment on table Base_AppendProperty.Property_Control_Length is '控件长度';
comment on table Base_AppendProperty.Property_Control_Style is '控件样式';
comment on table Base_AppendProperty.Property_Control_Validator is '验证控件';
comment on table Base_AppendProperty.Property_Colspan is '合并列';
comment on table Base_AppendProperty.Property_Event is '事件';

comment on table Base_AppendProperty.SortCode is '排序码';
comment on table Base_AppendProperty.DeleteMark is '删除标记';
comment on table Base_AppendProperty.CreateDate is '创建时间';
comment on table Base_AppendProperty.CreateUserId is '创建用户主键';

comment on table Base_AppendProperty.CreateUserName is '创建用户';
comment on table Base_AppendProperty.ModifyDate is '修改时间';
comment on table Base_AppendProperty.ModifyUserId is '修改用户主键';
comment on table Base_AppendProperty.ModifyUserName is '修改用户';


